2016-09-15 - 28034 - Spec - 2016 B2B Order report #CrystalReportDevelopment
SPECIFICATIONS
28034 - 2016 B2B Order report
Requirement Summary
Need to create new report for 2016 B2B Orders.
Admin Info
Purpose
|
Need to create new report for 2016 B2B Orders.
|
Requested By
|
Nicole Rybarczyk
|
Spec Created By
|
Dhananjay G
|
Spec Created Date
|
09/15/2016
|
Spec QA by
|
Uday Kumar P
|
Objects
|
B2B Orders
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
06
|
2
|
Documentation
|
02
|
3
|
Development/ Config
|
10
|
4
|
Unit test in DEV
|
02
|
5
|
Unit test in QUA
|
04
|
6
|
Other activity
|
00
|
|
TOTAL
|
24
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to create new report for 2016 B2B Orders.
Requirement: To find the total money made through customer portal orders in 2016.
Filter conditions needed:
Year: 2016
Orders: Open and shipped
Purchase order type: B2B
Fields needed: net quantity, net amount, customer information, open or shipped status, BNAME - reference field. It is a one-time temporary report.
In Scope:
New one time report for 2016 B2B Orders.
Out of Scope:
None
Solution Summary
1. Need to create the report with available fields in ECC source.
2. Need to apply the groupings for removing duplicate records in the report.
3. Need to write the filter conditions to get the data for B2B orders.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Solution Details
1. Need to create the report with required fields as below: net quantity, net amount, customer information, open or shipped status, BNAME - reference field.
2. Need to apply the grouping for removing duplicate records in the report. i.e VBAK-VBELN.
3. Need to write the filter conditions to get the data for B2B orders as below:
{VBAK.BSARK} in ['B2B'] AND {VBAK.ERDAT} in date(2016,1,1) to date(2016,12,31) AND {VBUK.LFGSK} IN ['A','B','C']
4. Need to promote the report into BI Production after successful validation.
Issues
None